﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'boogaloo_core_node_UpdateEntityKey_sp')
	BEGIN
		DROP  Procedure  boogaloo_core_node_UpdateEntityKey_sp
	END

GO

CREATE Procedure [dbo].boogaloo_core_node_UpdateEntityKey_sp
	(
		@node_id			INT					,
		@entity_key			UNIQUEIDENTIFIER	,
		@last_modified_by	NVARCHAR(50) = NULL
	)
AS
/***********************************************
'
' Boogaloo® - http://www.mindfly.com
' Copyright (c) 2009
' by Mindfly, Inc.
'
' Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated 
' documentation files (the "Software"), to deal in the Software without restriction, including without limitation 
' the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and 
' to permit persons to whom the Software is furnished to do so, subject to the following conditions:
'
' The above copyright notice and this permission notice shall be included in all copies or substantial portions 
' of the Software.
'
' THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES,
' INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
' DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
' SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR
' SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY,
' WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF
' THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

************************************************/
SET NOCOUNT OFF

IF @last_modified_by IS NULL
	SET @last_modified_by = USER_NAME()

UPDATE	boogaloo_node_tbl
SET		entity_key			= @entity_key
     ,	last_modified_date	= GETDATE()
     ,	last_modified_by	= @last_modified_by
WHERE	node_id				= @node_id     